WEBVTT

00:00.640 --> 00:04.460
Welcome to the solution for step one off for the final project.

00:04.550 --> 00:09.370
And here we are asked to identify the five stocks and get the respective stock takers.

00:09.500 --> 00:11.930
So let's have a look again at the case.

00:12.080 --> 00:17.390
We have our new client Mary Johnson and from nineteen hundred and ninety seven until today she has been

00:17.390 --> 00:22.910
solely invested in two five healthcare stocks that are today the most valuable healthcare stocks in

00:22.910 --> 00:26.690
the U.S. market in terms of market capitalization.

00:26.960 --> 00:33.170
And uh here in Step One We should work with the CSP file listings cleaned out CSP

00:35.880 --> 00:42.600
and first of all we import the library's pandas nonpayment plot lips Seabourn y finance and cufflinks

00:45.320 --> 00:48.380
and then we import our current listings on this deck.

00:48.390 --> 00:51.070
Uh Amex and New York Stock Exchange.

00:51.170 --> 00:59.530
And uh we set uh the symbol column as being the index and that's inspecting our listings that are set

01:04.900 --> 01:11.650
and now we should filter for the five largest healthcare stocks and five largest in terms of market

01:11.650 --> 01:17.620
capitalization and actually health care is a sector that we can find here in the column sector.

01:17.620 --> 01:21.020
So first of all I refer to all healthcare companies.

01:21.310 --> 01:27.940
And uh we can do this year with listings the DOT sector equals healthcare and be safe.

01:27.990 --> 01:30.460
The new data frame and the variable health.

01:30.460 --> 01:37.230
So let's say this year and then we are only interested in the five largest companies in terms of market

01:37.230 --> 01:38.820
capitalization.

01:38.820 --> 01:43.510
And we you see at the end largest method and be safe.

01:43.590 --> 01:49.470
The new data frame with the five largest healthcare companies and the variable large cap healthcare

01:51.130 --> 01:52.510
and have a look.

01:52.670 --> 01:59.200
So here we have for example Johnson and Johnson and Pfizer and here on the left hand side we have the

01:59.200 --> 02:00.160
ticker symbols.